Using Java to Add "Stored Procedures" to Databases
نویسندگان
چکیده
Th,e poper describcs our approach to o.cld.ing "stored procedure" capab'ility to a semantic database systerrt using Jaua byte-codes and, Jaro's abililU to dgnamicalLy load and esecute Jaua cotle. Seueral steps were necessaru: f,rst we added a ,laua appl'ication pragranrmer in.terface to the d,atqbase system; then we createcl. a database scherna to hold, Jaua etecutable cod.e; then we constructerl a Jqua class laad,er to sLlou co(Le to be Loaded frorn the databose; then we enabled the creation oJ Jaua oltjects and ere.utted the Jaua code for them. Otr approach is not spccific to our semantic database sgste,m, ralher it can serue as a re-cipe ,for adrling "stored procedures" to any clatabase system.
منابع مشابه
AMCIS 2002 Workshops and Panels VI: Technical Note: Implementing Java-Based Stored Technical Procedures in the Oracle Database
This technical note provides an introduction to writing stored procedures using the Java language. The primary purpose of the workshop is to demonstrate the steps required to publish a Java method inside the Oracle 8i Lite database environment.
متن کاملA Proposed Data Mining Methodology and its Application to Industrial Procedures
Data mining is the process of discovering correlations, patterns, trends or relationships by searching through a large amount of data stored in repositories, corporate databases, and data warehouses. Industrial procedures with the help of engineers, managers, and other specialists, comprise a broad field and have many tools and techniques in their problem-solving arsenal. The purpose of this st...
متن کاملWWW-based Image Management System
The main characteristics of the developed experimental image management system are presented in the paper. The system features a functional DICOM environment that includes distributed image archive and a platform independent and user-friendly interface for manipulating the data stored in the databases. The system offers authorised user access to information stored in the image databases. User a...
متن کاملWISH Query Composer
The WISH (With Intuitive Search Help) Query Composer is a software tool for composing form-based queries and their associated reports for relational databases. It incorporates the SQL and XML industry standards to generate user-friendly customizable queries and reports. It uses the very simple but flexible XML semantics to represent database schemas, SQL queries and result datasets, regardless ...
متن کاملUsing Aspect-Orientation to Add Persistency to Applications
This paper presents a comfortable and customizable persistence framework that supports the access of relational databases from Java applications. In order to keep the effort for implementation low, we show how to benefit from aspect-orientation. The framework has advantages over existing mapping tools: Flexibility is higher as the functionality can be freely designed. We demonstrate flexibility...
متن کامل